USE [Data]
GO

/****** Object:  StoredProcedure [Persona].[sp_consulta_vendedor_cotizador]    Script Date: 02/18/2013 15:38:20 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[Persona].[sp_consulta_vendedor_cotizador]') AND type in (N'P', N'PC'))
DROP PROCEDURE [Persona].[sp_consulta_vendedor_cotizador]
GO

USE [Data]
GO

/****** Object:  StoredProcedure [Persona].[sp_consulta_vendedor_cotizador]    Script Date: 02/18/2013 15:38:20 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO



CREATE PROCEDURE [Persona].[sp_consulta_vendedor_cotizador]

@VENDEDOR VARCHAR(50)

AS

set nocount ON

select 
	NombreImpresion, 
	Telefono1, 
	Telefono2, 
	Correo 
from Data.Persona.Vendedor 
	Where IdEstadoPersonaVendedor='A'
	and IdUsuario=@VENDEDOR
set nocount OFF


GO

